insert overwrite table jms_dwd.dwd_tab_report_shift_operate_base
select
   id                      as   id
  ,transport_center_code   as   transport_center_code
  ,transport_center_name   as   transport_center_name
  ,shift_start_time        as   shift_start_time
  ,shift_end_time          as   shift_end_time
  ,effect_start_time       as   effect_start_time
  ,effect_end_time         as   effect_end_time
  ,modify_by               as   modify_by
  ,modify_time             as   modify_time
  ,status_code             as   status_code
from jms_ods.tab_report_shift_operate
where dt = '{{ execution_date | cst_ds }}'
